CONNECT BY WITHOUT FILTERING
Short Description
CONNECT BY describes how LEVELs are created within hierarchical queries
Detailed Description
CONNECT BY describes how LEVELs are created within hierarchical queries. A hierarchical query needs a definition of how child and parent records are related, this is provided by the CONNECT BY .. PRIOR syntax.
WITHOUT FILTERING may be more efficient for smaller data sets as it generally performs one pass through the data.
Additional Links
- Tim Hall’s Oracle Base viedo clip - Hierarchical Queries in Oracle
- Oracle SQL Ref - Hierarchical Queries
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.